/**
 * Copyright 2009 Emory University
 * 
 * Permission is hereby granted, free of charge, to any person obtaining a
 * copy of this software and associated  documentation files (the "Software"),
 * to deal in the Software without restriction, including without limitation
 * the rights to use, copy, modify, merge, publish, distribute, sublicense, 
 * and/or sell copies of the Software, and to permit persons to whom the 
 * Software is furnished to do so, subject to the following conditions: The 
 * above copyright notice and this permission notice shall be included in all 
 * copies or substantial portions of the Software. 
 * 
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR 
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, 
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE 
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER 
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING 
 * FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
 * DEALINGS IN THE SOFTWARE.
 */
package com.markgrand.structuredSql
/**
 * Append the Seqs of values for a multi-row INSERT statement to a StringBuilder
 * 
 * @param values 
 *      A two dimensional structure of values. values(0) contains the values for 
 *      the first row of a table to be inserted. values(1) contains the values
 *      for the second row to be inserted.
 */
class InsertMultiRowValueList protected (val values:Seq[Seq[SQLColumnValueAppender]]) extends SQLInsertValueAppender {
  if (values.length==0) {
    throw new IllegalArgumentException("Values must contain data for at least one row.")
  }
  if (values(0).length==0) {
    throw new IllegalArgumentException("Rows must contain at least one value.")
  }
  
  def append(builder:StringBuilder) {
    builder.append("VALUES ")
    val rowIterator = values.iterator
    val firstRow = rowIterator.next
    appendRow(firstRow, builder)
    val rowLength = firstRow.length
    while(rowIterator.hasNext) {
      builder.append(",")
      val thisRow = rowIterator.next
      if (rowLength != thisRow.length) {
        val msg = ("Same number of values must be provided for all rows. Found rows containing " +
                  rowLength + " values and " + thisRow.length + " values")
        throw new IllegalArgumentException(msg)
      }
      appendRow(thisRow, builder)
    }
  }
}

object InsertMultiRowValueList {
  /**
   * Create an InsertValueList for inserting a single row.
   */
  def apply(rowValues:Seq[Seq[SQLColumnValueAppender]]) = new InsertMultiRowValueList(rowValues) 
}
